<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<!-- NewPage -->
<html lang="en">
<head>
<title>HSSFCell (POI API Documentation)</title>
<link rel="stylesheet" type="text/css" href="../../../../../stylesheet.css" title="Style">
</head>
<body>
<script type="text/javascript"><!--
    if (location.href.indexOf('is-external=true') == -1) {
        parent.document.title="HSSFCell (POI API Documentation)";
    }
//-->
</script>
<noscript>
<div>JavaScript is disabled on your browser.</div>
</noscript>
<!-- ========= START OF TOP NAVBAR ======= -->
<div class="topNav"><a name="navbar_top">
<!--   -->
</a><a href="#skip-navbar_top" title="Skip navigation links"></a><a name="navbar_top_firstrow">
<!--   -->
</a>
<ul class="navList" title="Navigation">
<li><a href="../../../../../overview-summary.html">Overview</a></li>
<li><a href="package-summary.html">Package</a></li>
<li class="navBarCell1Rev">Class</li>
<li><a href="class-use/HSSFCell.html">Use</a></li>
<li><a href="package-tree.html">Tree</a></li>
<li><a href="../../../../../deprecated-list.html">Deprecated</a></li>
<li><a href="../../../../../index-all.html">Index</a></li>
<li><a href="../../../../../help-doc.html">Help</a></li>
</ul>
</div>
<div class="subNav">
<ul class="navList">
<li><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFBorderFormatting.html" title="class in org.apache.poi.hssf.usermodel"><span class="strong">PREV CLASS</span></a></li>
<li><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html" title="class in org.apache.poi.hssf.usermodel"><span class="strong">NEXT CLASS</span></a></li>
</ul>
<ul class="navList">
<li><a href="../../../../../index.html?org/apache/poi/hssf/usermodel/HSSFCell.html" target="_top">FRAMES</a></li>
<li><a href="HSSFCell.html" target="_top">NO FRAMES</a></li>
</ul>
<ul class="navList" id="allclasses_navbar_top">
<li><a href="../../../../../allclasses-noframe.html">All Classes</a></li>
</ul>
<div>
<script type="text/javascript"><!--
  allClassesLink = document.getElementById("allclasses_navbar_top");
  if(window==top) {
    allClassesLink.style.display = "block";
  }
  else {
    allClassesLink.style.display = "none";
  }
  //-->
</script>
</div>
<div>
<ul class="subNavList">
<li>SUMMARY:&nbsp;</li>
<li>NESTED&nbsp;|&nbsp;</li>
<li><a href="#field_summary">FIELD</a>&nbsp;|&nbsp;</li>
<li><a href="#constructor_summary">CONSTR</a>&nbsp;|&nbsp;</li>
<li><a href="#method_summary">METHOD</a></li>
</ul>
<ul class="subNavList">
<li>DETAIL:&nbsp;</li>
<li><a href="#field_detail">FIELD</a>&nbsp;|&nbsp;</li>
<li><a href="#constructor_detail">CONSTR</a>&nbsp;|&nbsp;</li>
<li><a href="#method_detail">METHOD</a></li>
</ul>
</div>
<a name="skip-navbar_top">
<!--   -->
</a></div>
<!-- ========= END OF TOP NAVBAR ========= -->
<!-- ======== START OF CLASS DATA ======== -->
<div class="header">
<p class="subTitle">org.apache.poi.hssf.usermodel</p>
<h2 title="Class HSSFCell" class="title">Class HSSFCell</h2>
</div>
<div class="contentContainer">
<ul class="inheritance">
<li>java.lang.Object</li>
<li>
<ul class="inheritance">
<li>org.apache.poi.hssf.usermodel.HSSFCell</li>
</ul>
</li>
</ul>
<div class="description">
<ul class="blockList">
<li class="blockList">
<dl>
<dt>All Implemented Interfaces:</dt>
<dd><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html" title="interface in org.apache.poi.ss.usermodel">Cell</a></dd>
</dl>
<hr>
<br>
<pre>public class <strong>HSSFCell</strong>
extends java.lang.Object
implements <a href="../../../../../org/apache/poi/ss/usermodel/Cell.html" title="interface in org.apache.poi.ss.usermodel">Cell</a></pre>
<div class="block">High level representation of a cell in a row of a spreadsheet.
 Cells can be numeric, formula-based or string-based (text).  The cell type
 specifies this.  String cells cannot contain numbers and numeric cells cannot
 contain strings (at least according to our model).  Client apps should do the
 conversions themselves.  Formula cells have the formula string, as well as
 the formula result, which can be numeric or string.
 <p>
 Cells should have their number (0 based) before being added to a row.  Only
 cells that have values should be added.
 <p></div>
</li>
</ul>
</div>
<div class="summary">
<ul class="blockList">
<li class="blockList">
<!-- =========== FIELD SUMMARY =========== -->
<ul class="blockList">
<li class="blockList"><a name="field_summary">
<!--   -->
</a>
<h3>Field Summary</h3>
<table class="overviewSummary" border="0" cellpadding="3" cellspacing="0" summary="Field Summary table, listing fields, and an explanation">
<caption><span>Fields</span><span class="tabEnd">&nbsp;</span></caption>
<tr>
<th class="colFirst" scope="col">Modifier and Type</th>
<th class="colLast" scope="col">Field and Description</th>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCell.html#ENCODING_COMPRESSED_UNICODE">ENCODING_COMPRESSED_UNICODE</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCell.html#ENCODING_UNCHANGED">ENCODING_UNCHANGED</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCell.html#ENCODING_UTF_16">ENCODING_UTF_16</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static int</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCell.html#LAST_COLUMN_NUMBER">LAST_COLUMN_NUMBER</a></strong></code>
<div class="block">The maximum  number of columns in BIFF8</div>
</td>
</tr>
</table>
<ul class="blockList">
<li class="blockList"><a name="fields_inherited_from_class_org.apache.poi.ss.usermodel.Cell">
<!--   -->
</a>
<h3>Fields inherited from interface&nbsp;org.apache.poi.ss.usermodel.<a href="../../../../../org/apache/poi/ss/usermodel/Cell.html" title="interface in org.apache.poi.ss.usermodel">Cell</a></h3>
<code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#CELL_TYPE_BLANK">CELL_TYPE_BLANK</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#CELL_TYPE_BOOLEAN">CELL_TYPE_BOOLEAN</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#CELL_TYPE_ERROR">CELL_TYPE_ERROR</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#CELL_TYPE_FORMULA">CELL_TYPE_FORMULA</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#CELL_TYPE_NUMERIC">CELL_TYPE_NUMERIC</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#CELL_TYPE_STRING">CELL_TYPE_STRING</a></code></li>
</ul>
</li>
</ul>
<!-- ======== CONSTRUCTOR SUMMARY ======== -->
<ul class="blockList">
<li class="blockList"><a name="constructor_summary">
<!--   -->
</a>
<h3>Constructor Summary</h3>
<table class="overviewSummary" border="0" cellpadding="3" cellspacing="0" summary="Constructor Summary table, listing constructors, and an explanation">
<caption><span>Constructors</span><span class="tabEnd">&nbsp;</span></caption>
<tr>
<th class="colFirst" scope="col">Modifier</th>
<th class="colLast" scope="col">Constructor and Description</th>
</tr>
<tr class="altColor">
<td class="colFirst"><code>protected </code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCell.html#HSSFCell(org.apache.poi.hssf.usermodel.HSSFWorkbook, org.apache.poi.hssf.usermodel.HSSFSheet, org.apache.poi.hssf.record.CellValueRecordInterface)">HSSFCell</a></strong>(<a href="../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html" title="class in org.apache.poi.hssf.usermodel">HSSFWorkbook</a>&nbsp;book,
        <a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html" title="class in org.apache.poi.hssf.usermodel">HSSFSheet</a>&nbsp;sheet,
        <a href="../../../../../org/apache/poi/hssf/record/CellValueRecordInterface.html" title="interface in org.apache.poi.hssf.record">CellValueRecordInterface</a>&nbsp;cval)</code>
<div class="block">Creates an HSSFCell from a CellValueRecordInterface.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>protected </code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCell.html#HSSFCell(org.apache.poi.hssf.usermodel.HSSFWorkbook, org.apache.poi.hssf.usermodel.HSSFSheet, int, short)">HSSFCell</a></strong>(<a href="../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html" title="class in org.apache.poi.hssf.usermodel">HSSFWorkbook</a>&nbsp;book,
        <a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html" title="class in org.apache.poi.hssf.usermodel">HSSFSheet</a>&nbsp;sheet,
        int&nbsp;row,
        short&nbsp;col)</code>
<div class="block">Creates new Cell - Should only be called by HSSFRow.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>protected </code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCell.html#HSSFCell(org.apache.poi.hssf.usermodel.HSSFWorkbook, org.apache.poi.hssf.usermodel.HSSFSheet, int, short, int)">HSSFCell</a></strong>(<a href="../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html" title="class in org.apache.poi.hssf.usermodel">HSSFWorkbook</a>&nbsp;book,
        <a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html" title="class in org.apache.poi.hssf.usermodel">HSSFSheet</a>&nbsp;sheet,
        int&nbsp;row,
        short&nbsp;col,
        int&nbsp;type)</code>
<div class="block">Creates new Cell - Should only be called by HSSFRow.</div>
</td>
</tr>
</table>
</li>
</ul>
<!-- ========== METHOD SUMMARY =========== -->
<ul class="blockList">
<li class="blockList"><a name="method_summary">
<!--   -->
</a>
<h3>Method Summary</h3>
<table class="overviewSummary" border="0" cellpadding="3" cellspacing="0" summary="Method Summary table, listing methods, and an explanation">
<caption><span>Methods</span><span class="tabEnd">&nbsp;</span></caption>
<tr>
<th class="colFirst" scope="col">Modifier and Type</th>
<th class="colLast" scope="col">Method and Description</th>
</tr>
<tr class="altColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCell.html#getArrayFormulaRange()">getArrayFormulaRange</a></strong>()</code>
<div class="block">Only valid for array formula cells</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCell.html#getBooleanCellValue()">getBooleanCellValue</a></strong>()</code>
<div class="block">get the value of the cell as a boolean.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>protected <a href="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html" title="class in org.apache.poi.hssf.model">InternalWorkbook</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCell.html#getBoundWorkbook()">getBoundWorkbook</a></strong>()</code>
<div class="block">Returns the Workbook that this Cell is bound to</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>int</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCell.html#getCachedFormulaResultType()">getCachedFormulaResultType</a></strong>()</code>
<div class="block">Only valid for formula cells</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFComment.html" title="class in org.apache.poi.hssf.usermodel">HSSFComment</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCell.html#getCellComment()">getCellComment</a></strong>()</code>
<div class="block">Returns comment associated with this cell</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>java.lang.String</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCell.html#getCellFormula()">getCellFormula</a></strong>()</code>
<div class="block">Return a formula for the cell, for example, <code>SUM(C4:E4)</code></div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCell.html#getCellNum()">getCellNum</a></strong>()</code>
<div class="block"><strong>Deprecated.</strong>&nbsp;
<div class="block"><i>(Oct 2008) use <a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCell.html#getColumnIndex()"><code>getColumnIndex()</code></a></i></div>
</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html" title="class in org.apache.poi.hssf.usermodel">HSSFCellStyle</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCell.html#getCellStyle()">getCellStyle</a></strong>()</code>
<div class="block">get the style for the cell.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>int</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCell.html#getCellType()">getCellType</a></strong>()</code>
<div class="block">get the cells type (numeric, formula or string)</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>protected <a href="../../../../../org/apache/poi/hssf/record/CellValueRecordInterface.html" title="interface in org.apache.poi.hssf.record">CellValueRecordInterface</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCell.html#getCellValueRecord()">getCellValueRecord</a></strong>()</code>
<div class="block">Should only be used by HSSFSheet and friends.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>int</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCell.html#getColumnIndex()">getColumnIndex</a></strong>()</code>
<div class="block">Returns column index of this cell</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>java.util.Date</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCell.html#getDateCellValue()">getDateCellValue</a></strong>()</code>
<div class="block">Get the value of the cell as a date.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>byte</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCell.html#getErrorCellValue()">getErrorCellValue</a></strong>()</code>
<div class="block">get the value of the cell as an error code.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFHyperlink.html" title="class in org.apache.poi.hssf.usermodel">HSSFHyperlink</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCell.html#getHyperlink()">getHyperlink</a></strong>()</code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>double</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCell.html#getNumericCellValue()">getNumericCellValue</a></strong>()</code>
<div class="block">Get the value of the cell as a number.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFRichTextString.html" title="class in org.apache.poi.hssf.usermodel">HSSFRichTextString</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCell.html#getRichStringCellValue()">getRichStringCellValue</a></strong>()</code>
<div class="block">get the value of the cell as a string - for numeric cells we throw an exception.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFRow.html" title="class in org.apache.poi.hssf.usermodel">HSSFRow</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCell.html#getRow()">getRow</a></strong>()</code>
<div class="block">Returns the HSSFRow this cell belongs to</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>int</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCell.html#getRowIndex()">getRowIndex</a></strong>()</code>
<div class="block">Returns row index of a row in the sheet that contains this cell</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html" title="class in org.apache.poi.hssf.usermodel">HSSFSheet</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCell.html#getSheet()">getSheet</a></strong>()</code>
<div class="block">Returns the HSSFSheet this cell belongs to</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>java.lang.String</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCell.html#getStringCellValue()">getStringCellValue</a></strong>()</code>
<div class="block">get the value of the cell as a string - for numeric cells we throw an exception.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCell.html#isPartOfArrayFormulaGroup()">isPartOfArrayFormulaGroup</a></strong>()</code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCell.html#removeCellComment()">removeCellComment</a></strong>()</code>
<div class="block">Removes the comment for this cell, if
  there is one.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCell.html#removeHyperlink()">removeHyperlink</a></strong>()</code>
<div class="block">Removes the hyperlink for this cell, if there is one.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCell.html#setAsActiveCell()">setAsActiveCell</a></strong>()</code>
<div class="block">Sets this cell as the active cell for the worksheet</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCell.html#setCellComment(org.apache.poi.ss.usermodel.Comment)">setCellComment</a></strong>(<a href="../../../../../org/apache/poi/ss/usermodel/Comment.html" title="interface in org.apache.poi.ss.usermodel">Comment</a>&nbsp;comment)</code>
<div class="block">Assign a comment to this cell.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCell.html#setCellErrorValue(byte)">setCellErrorValue</a></strong>(byte&nbsp;errorCode)</code>
<div class="block">set a error value for the cell</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCell.html#setCellFormula(java.lang.String)">setCellFormula</a></strong>(java.lang.String&nbsp;formula)</code>
<div class="block">Sets formula for this cell.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCell.html#setCellNum(short)">setCellNum</a></strong>(short&nbsp;num)</code>
<div class="block"><strong>Deprecated.</strong>&nbsp;
<div class="block"><i>(Jan 2008) Doesn't update the row's idea of what cell this is, use <a href="../../../../../org/apache/poi/hssf/usermodel/HSSFRow.html#moveCell(org.apache.poi.hssf.usermodel.HSSFCell, short)"><code>HSSFRow.moveCell(HSSFCell, short)</code></a> instead</i></div>
</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCell.html#setCellStyle(org.apache.poi.ss.usermodel.CellStyle)">setCellStyle</a></strong>(<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a>&nbsp;style)</code>
<div class="block">set the style for the cell.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCell.html#setCellStyle(org.apache.poi.hssf.usermodel.HSSFCellStyle)">setCellStyle</a></strong>(<a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html" title="class in org.apache.poi.hssf.usermodel">HSSFCellStyle</a>&nbsp;style)</code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCell.html#setCellType(int)">setCellType</a></strong>(int&nbsp;cellType)</code>
<div class="block">Set the cells type (numeric, formula or string).</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCell.html#setCellValue(boolean)">setCellValue</a></strong>(boolean&nbsp;value)</code>
<div class="block">set a boolean value for the cell</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCell.html#setCellValue(java.util.Calendar)">setCellValue</a></strong>(java.util.Calendar&nbsp;value)</code>
<div class="block">set a date value for the cell.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCell.html#setCellValue(java.util.Date)">setCellValue</a></strong>(java.util.Date&nbsp;value)</code>
<div class="block">set a date value for the cell.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCell.html#setCellValue(double)">setCellValue</a></strong>(double&nbsp;value)</code>
<div class="block">set a numeric value for the cell</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCell.html#setCellValue(org.apache.poi.ss.usermodel.RichTextString)">setCellValue</a></strong>(<a href="../../../../../org/apache/poi/ss/usermodel/RichTextString.html" title="interface in org.apache.poi.ss.usermodel">RichTextString</a>&nbsp;value)</code>
<div class="block">Set a string value for the cell.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCell.html#setCellValue(java.lang.String)">setCellValue</a></strong>(java.lang.String&nbsp;value)</code>
<div class="block">set a string value for the cell.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCell.html#setHyperlink(org.apache.poi.ss.usermodel.Hyperlink)">setHyperlink</a></strong>(<a href="../../../../../org/apache/poi/ss/usermodel/Hyperlink.html" title="interface in org.apache.poi.ss.usermodel">Hyperlink</a>&nbsp;hyperlink)</code>
<div class="block">Assign a hyperlink to this cell.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>java.lang.String</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCell.html#toString()">toString</a></strong>()</code>
<div class="block">Returns a string representation of the cell

 This method returns a simple representation,
 anthing more complex should be in user code, with
 knowledge of the semantics of the sheet being processed.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>protected void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCell.html#updateCellNum(short)">updateCellNum</a></strong>(short&nbsp;num)</code>
<div class="block">Updates the cell record's idea of what
  column it belongs in (0 based)</div>
</td>
</tr>
</table>
<ul class="blockList">
<li class="blockList"><a name="methods_inherited_from_class_java.lang.Object">
<!--   -->
</a>
<h3>Methods inherited from class&nbsp;java.lang.Object</h3>
<code>clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait</code></li>
</ul>
</li>
</ul>
</li>
</ul>
</div>
<div class="details">
<ul class="blockList">
<li class="blockList">
<!-- ============ FIELD DETAIL =========== -->
<ul class="blockList">
<li class="blockList"><a name="field_detail">
<!--   -->
</a>
<h3>Field Detail</h3>
<a name="LAST_COLUMN_NUMBER">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>LAST_COLUMN_NUMBER</h4>
<pre>public static final&nbsp;int LAST_COLUMN_NUMBER</pre>
<div class="block">The maximum  number of columns in BIFF8</div>
</li>
</ul>
<a name="ENCODING_UNCHANGED">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>ENCODING_UNCHANGED</h4>
<pre>public static final&nbsp;short ENCODING_UNCHANGED</pre>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.hssf.usermodel.HSSFCell.ENCODING_UNCHANGED">Constant Field Values</a></dd></dl>
</li>
</ul>
<a name="ENCODING_COMPRESSED_UNICODE">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>ENCODING_COMPRESSED_UNICODE</h4>
<pre>public static final&nbsp;short ENCODING_COMPRESSED_UNICODE</pre>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.hssf.usermodel.HSSFCell.ENCODING_COMPRESSED_UNICODE">Constant Field Values</a></dd></dl>
</li>
</ul>
<a name="ENCODING_UTF_16">
<!--   -->
</a>
<ul class="blockListLast">
<li class="blockList">
<h4>ENCODING_UTF_16</h4>
<pre>public static final&nbsp;short ENCODING_UTF_16</pre>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.hssf.usermodel.HSSFCell.ENCODING_UTF_16">Constant Field Values</a></dd></dl>
</li>
</ul>
</li>
</ul>
<!-- ========= CONSTRUCTOR DETAIL ======== -->
<ul class="blockList">
<li class="blockList"><a name="constructor_detail">
<!--   -->
</a>
<h3>Constructor Detail</h3>
<a name="HSSFCell(org.apache.poi.hssf.usermodel.HSSFWorkbook, org.apache.poi.hssf.usermodel.HSSFSheet, int, short)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>HSSFCell</h4>
<pre>protected&nbsp;HSSFCell(<a href="../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html" title="class in org.apache.poi.hssf.usermodel">HSSFWorkbook</a>&nbsp;book,
        <a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html" title="class in org.apache.poi.hssf.usermodel">HSSFSheet</a>&nbsp;sheet,
        int&nbsp;row,
        short&nbsp;col)</pre>
<div class="block">Creates new Cell - Should only be called by HSSFRow.  This creates a cell
 from scratch.
 <p>
 When the cell is initially created it is set to CELL_TYPE_BLANK. Cell types
 can be changed/overwritten by calling setCellValue with the appropriate
 type as a parameter although conversions from one type to another may be
 prohibited.</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>book</code> - - Workbook record of the workbook containing this cell</dd><dd><code>sheet</code> - - Sheet record of the sheet containing this cell</dd><dd><code>row</code> - - the row of this cell</dd><dd><code>col</code> - - the column for this cell</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFRow.html#createCell(short)"><code>HSSFRow.createCell(short)</code></a></dd></dl>
</li>
</ul>
<a name="HSSFCell(org.apache.poi.hssf.usermodel.HSSFWorkbook, org.apache.poi.hssf.usermodel.HSSFSheet, int, short, int)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>HSSFCell</h4>
<pre>protected&nbsp;HSSFCell(<a href="../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html" title="class in org.apache.poi.hssf.usermodel">HSSFWorkbook</a>&nbsp;book,
        <a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html" title="class in org.apache.poi.hssf.usermodel">HSSFSheet</a>&nbsp;sheet,
        int&nbsp;row,
        short&nbsp;col,
        int&nbsp;type)</pre>
<div class="block">Creates new Cell - Should only be called by HSSFRow.  This creates a cell
 from scratch.</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>book</code> - - Workbook record of the workbook containing this cell</dd><dd><code>sheet</code> - - Sheet record of the sheet containing this cell</dd><dd><code>row</code> - - the row of this cell</dd><dd><code>col</code> - - the column for this cell</dd><dd><code>type</code> - - CELL_TYPE_NUMERIC, CELL_TYPE_STRING, CELL_TYPE_FORMULA, CELL_TYPE_BLANK,
                CELL_TYPE_BOOLEAN, CELL_TYPE_ERROR
                Type of cell</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFRow.html#createCell(short, int)"><code>HSSFRow.createCell(short,int)</code></a></dd></dl>
</li>
</ul>
<a name="HSSFCell(org.apache.poi.hssf.usermodel.HSSFWorkbook, org.apache.poi.hssf.usermodel.HSSFSheet, org.apache.poi.hssf.record.CellValueRecordInterface)">
<!--   -->
</a>
<ul class="blockListLast">
<li class="blockList">
<h4>HSSFCell</h4>
<pre>protected&nbsp;HSSFCell(<a href="../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html" title="class in org.apache.poi.hssf.usermodel">HSSFWorkbook</a>&nbsp;book,
        <a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html" title="class in org.apache.poi.hssf.usermodel">HSSFSheet</a>&nbsp;sheet,
        <a href="../../../../../org/apache/poi/hssf/record/CellValueRecordInterface.html" title="interface in org.apache.poi.hssf.record">CellValueRecordInterface</a>&nbsp;cval)</pre>
<div class="block">Creates an HSSFCell from a CellValueRecordInterface.  HSSFSheet uses this when
 reading in cells from an existing sheet.</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>book</code> - - Workbook record of the workbook containing this cell</dd><dd><code>sheet</code> - - Sheet record of the sheet containing this cell</dd><dd><code>cval</code> - - the Cell Value Record we wish to represent</dd></dl>
</li>
</ul>
</li>
</ul>
<!-- ============ METHOD DETAIL ========== -->
<ul class="blockList">
<li class="blockList"><a name="method_detail">
<!--   -->
</a>
<h3>Method Detail</h3>
<a name="getSheet()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getSheet</h4>
<pre>public&nbsp;<a href="../../../../../org/apache/poi/hssf/usermodel/HSSFSheet.html" title="class in org.apache.poi.hssf.usermodel">HSSFSheet</a>&nbsp;getSheet()</pre>
<div class="block">Returns the HSSFSheet this cell belongs to</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#getSheet()">getSheet</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html" title="interface in org.apache.poi.ss.usermodel">Cell</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>the HSSFSheet that owns this cell</dd></dl>
</li>
</ul>
<a name="getRow()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getRow</h4>
<pre>public&nbsp;<a href="../../../../../org/apache/poi/hssf/usermodel/HSSFRow.html" title="class in org.apache.poi.hssf.usermodel">HSSFRow</a>&nbsp;getRow()</pre>
<div class="block">Returns the HSSFRow this cell belongs to</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#getRow()">getRow</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html" title="interface in org.apache.poi.ss.usermodel">Cell</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>the HSSFRow that owns this cell</dd></dl>
</li>
</ul>
<a name="getBoundWorkbook()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getBoundWorkbook</h4>
<pre>protected&nbsp;<a href="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html" title="class in org.apache.poi.hssf.model">InternalWorkbook</a>&nbsp;getBoundWorkbook()</pre>
<div class="block">Returns the Workbook that this Cell is bound to</div>
</li>
</ul>
<a name="getRowIndex()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getRowIndex</h4>
<pre>public&nbsp;int&nbsp;getRowIndex()</pre>
<div class="block"><strong>Description copied from interface:&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#getRowIndex()">Cell</a></code></strong></div>
<div class="block">Returns row index of a row in the sheet that contains this cell</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#getRowIndex()">getRowIndex</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html" title="interface in org.apache.poi.ss.usermodel">Cell</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>the (zero based) index of the row containing this cell</dd></dl>
</li>
</ul>
<a name="setCellNum(short)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setCellNum</h4>
<pre>public&nbsp;void&nbsp;setCellNum(short&nbsp;num)</pre>
<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>(Jan 2008) Doesn't update the row's idea of what cell this is, use <a href="../../../../../org/apache/poi/hssf/usermodel/HSSFRow.html#moveCell(org.apache.poi.hssf.usermodel.HSSFCell, short)"><code>HSSFRow.moveCell(HSSFCell, short)</code></a> instead</i></div>
<div class="block">Set the cell's number within the row (0 based).</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>num</code> - short the cell number</dd></dl>
</li>
</ul>
<a name="updateCellNum(short)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>updateCellNum</h4>
<pre>protected&nbsp;void&nbsp;updateCellNum(short&nbsp;num)</pre>
<div class="block">Updates the cell record's idea of what
  column it belongs in (0 based)</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>num</code> - the new cell number</dd></dl>
</li>
</ul>
<a name="getCellNum()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getCellNum</h4>
<pre>public&nbsp;short&nbsp;getCellNum()</pre>
<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>(Oct 2008) use <a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCell.html#getColumnIndex()"><code>getColumnIndex()</code></a></i></div>
</li>
</ul>
<a name="getColumnIndex()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getColumnIndex</h4>
<pre>public&nbsp;int&nbsp;getColumnIndex()</pre>
<div class="block"><strong>Description copied from interface:&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#getColumnIndex()">Cell</a></code></strong></div>
<div class="block">Returns column index of this cell</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#getColumnIndex()">getColumnIndex</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html" title="interface in org.apache.poi.ss.usermodel">Cell</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>zero-based column index of a column in a sheet.</dd></dl>
</li>
</ul>
<a name="setCellType(int)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setCellType</h4>
<pre>public&nbsp;void&nbsp;setCellType(int&nbsp;cellType)</pre>
<div class="block">Set the cells type (numeric, formula or string).
 If the cell currently contains a value, the value will
  be converted to match the new type, if possible.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#setCellType(int)">setCellType</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html" title="interface in org.apache.poi.ss.usermodel">Cell</a></code></dd>
<dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#CELL_TYPE_NUMERIC"><code>Cell.CELL_TYPE_NUMERIC</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#CELL_TYPE_STRING"><code>Cell.CELL_TYPE_STRING</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#CELL_TYPE_FORMULA"><code>Cell.CELL_TYPE_FORMULA</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#CELL_TYPE_BLANK"><code>Cell.CELL_TYPE_BLANK</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#CELL_TYPE_BOOLEAN"><code>Cell.CELL_TYPE_BOOLEAN</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#CELL_TYPE_ERROR"><code>Cell.CELL_TYPE_ERROR</code></a></dd></dl>
</li>
</ul>
<a name="getCellType()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getCellType</h4>
<pre>public&nbsp;int&nbsp;getCellType()</pre>
<div class="block">get the cells type (numeric, formula or string)</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#getCellType()">getCellType</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html" title="interface in org.apache.poi.ss.usermodel">Cell</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>the cell type</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#CELL_TYPE_STRING"><code>Cell.CELL_TYPE_STRING</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#CELL_TYPE_NUMERIC"><code>Cell.CELL_TYPE_NUMERIC</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#CELL_TYPE_FORMULA"><code>Cell.CELL_TYPE_FORMULA</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#CELL_TYPE_BOOLEAN"><code>Cell.CELL_TYPE_BOOLEAN</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#CELL_TYPE_ERROR"><code>Cell.CELL_TYPE_ERROR</code></a></dd></dl>
</li>
</ul>
<a name="setCellValue(double)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setCellValue</h4>
<pre>public&nbsp;void&nbsp;setCellValue(double&nbsp;value)</pre>
<div class="block">set a numeric value for the cell</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#setCellValue(double)">setCellValue</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html" title="interface in org.apache.poi.ss.usermodel">Cell</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>value</code> - the numeric value to set this cell to.  For formulas we'll set the
        precalculated value, for numerics we'll set its value. For other types we
        will change the cell to a numeric cell and set its value.</dd></dl>
</li>
</ul>
<a name="setCellValue(java.util.Date)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setCellValue</h4>
<pre>public&nbsp;void&nbsp;setCellValue(java.util.Date&nbsp;value)</pre>
<div class="block">set a date value for the cell. Excel treats dates as numeric so you will need to format the cell as
 a date.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#setCellValue(java.util.Date)">setCellValue</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html" title="interface in org.apache.poi.ss.usermodel">Cell</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>value</code> - the date value to set this cell to.  For formulas we'll set the
        precalculated value, for numerics we'll set its value. For other types we
        will change the cell to a numeric cell and set its value.</dd></dl>
</li>
</ul>
<a name="setCellValue(java.util.Calendar)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setCellValue</h4>
<pre>public&nbsp;void&nbsp;setCellValue(java.util.Calendar&nbsp;value)</pre>
<div class="block">set a date value for the cell. Excel treats dates as numeric so you will need to format the cell as
 a date.

 This will set the cell value based on the Calendar's timezone. As Excel
 does not support timezones this means that both 20:00+03:00 and
 20:00-03:00 will be reported as the same value (20:00) even that there
 are 6 hours difference between the two times. This difference can be
 preserved by using <code>setCellValue(value.getTime())</code> which will
 automatically shift the times to the default timezone.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#setCellValue(java.util.Calendar)">setCellValue</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html" title="interface in org.apache.poi.ss.usermodel">Cell</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>value</code> - the date value to set this cell to.  For formulas we'll set the
        precalculated value, for numerics we'll set its value. For othertypes we
        will change the cell to a numeric cell and set its value.</dd></dl>
</li>
</ul>
<a name="setCellValue(java.lang.String)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setCellValue</h4>
<pre>public&nbsp;void&nbsp;setCellValue(java.lang.String&nbsp;value)</pre>
<div class="block">set a string value for the cell.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#setCellValue(java.lang.String)">setCellValue</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html" title="interface in org.apache.poi.ss.usermodel">Cell</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>value</code> - value to set the cell to.  For formulas we'll set the formula
 cached string result, for String cells we'll set its value. For other types we will
 change the cell to a string cell and set its value.
 If value is null then we will change the cell to a Blank cell.</dd></dl>
</li>
</ul>
<a name="setCellValue(org.apache.poi.ss.usermodel.RichTextString)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setCellValue</h4>
<pre>public&nbsp;void&nbsp;setCellValue(<a href="../../../../../org/apache/poi/ss/usermodel/RichTextString.html" title="interface in org.apache.poi.ss.usermodel">RichTextString</a>&nbsp;value)</pre>
<div class="block">Set a string value for the cell.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#setCellValue(org.apache.poi.ss.usermodel.RichTextString)">setCellValue</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html" title="interface in org.apache.poi.ss.usermodel">Cell</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>value</code> - value to set the cell to.  For formulas we'll set the formula
 string, for String cells we'll set its value.  For other types we will
 change the cell to a string cell and set its value.
 If value is <code>null</code> then we will change the cell to a Blank cell.</dd></dl>
</li>
</ul>
<a name="setCellFormula(java.lang.String)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setCellFormula</h4>
<pre>public&nbsp;void&nbsp;setCellFormula(java.lang.String&nbsp;formula)</pre>
<div class="block"><strong>Description copied from interface:&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#setCellFormula(java.lang.String)">Cell</a></code></strong></div>
<div class="block">Sets formula for this cell.
 <p>
 Note, this method only sets the formula string and does not calculate the formula value.
 To set the precalculated value use <a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#setCellValue(double)"><code>Cell.setCellValue(double)</code></a> or <a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#setCellValue(java.lang.String)"><code>Cell.setCellValue(String)</code></a>
 </p></div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#setCellFormula(java.lang.String)">setCellFormula</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html" title="interface in org.apache.poi.ss.usermodel">Cell</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>formula</code> - the formula to set, e.g. <code>"SUM(C4:E4)"</code>.
  If the argument is <code>null</code> then the current formula is removed.</dd></dl>
</li>
</ul>
<a name="getCellFormula()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getCellFormula</h4>
<pre>public&nbsp;java.lang.String&nbsp;getCellFormula()</pre>
<div class="block"><strong>Description copied from interface:&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#getCellFormula()">Cell</a></code></strong></div>
<div class="block">Return a formula for the cell, for example, <code>SUM(C4:E4)</code></div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#getCellFormula()">getCellFormula</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html" title="interface in org.apache.poi.ss.usermodel">Cell</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>a formula for the cell</dd></dl>
</li>
</ul>
<a name="getNumericCellValue()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getNumericCellValue</h4>
<pre>public&nbsp;double&nbsp;getNumericCellValue()</pre>
<div class="block">Get the value of the cell as a number.
 For strings we throw an exception.
 For blank cells we return a 0.
 See <a href="../../../../../org/apache/poi/hssf/usermodel/HSSFDataFormatter.html" title="class in org.apache.poi.hssf.usermodel"><code>HSSFDataFormatter</code></a> for turning this
  number into a string similar to that which
  Excel would render this number as.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#getNumericCellValue()">getNumericCellValue</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html" title="interface in org.apache.poi.ss.usermodel">Cell</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>the value of the cell as a number</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/DataFormatter.html" title="class in org.apache.poi.ss.usermodel"><code>for turning this number into a string similar to that which Excel would render this number as.</code></a></dd></dl>
</li>
</ul>
<a name="getDateCellValue()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getDateCellValue</h4>
<pre>public&nbsp;java.util.Date&nbsp;getDateCellValue()</pre>
<div class="block">Get the value of the cell as a date.
 For strings we throw an exception.
 For blank cells we return a null.
 See <a href="../../../../../org/apache/poi/hssf/usermodel/HSSFDataFormatter.html" title="class in org.apache.poi.hssf.usermodel"><code>HSSFDataFormatter</code></a> for formatting
  this date into a string similar to how excel does.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#getDateCellValue()">getDateCellValue</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html" title="interface in org.apache.poi.ss.usermodel">Cell</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>the value of the cell as a date</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/DataFormatter.html" title="class in org.apache.poi.ss.usermodel"><code>for formatting  this date into a string similar to how excel does.</code></a></dd></dl>
</li>
</ul>
<a name="getStringCellValue()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getStringCellValue</h4>
<pre>public&nbsp;java.lang.String&nbsp;getStringCellValue()</pre>
<div class="block">get the value of the cell as a string - for numeric cells we throw an exception.
 For blank cells we return an empty string.
 For formulaCells that are not string Formulas, we throw an exception</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#getStringCellValue()">getStringCellValue</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html" title="interface in org.apache.poi.ss.usermodel">Cell</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>the value of the cell as a string</dd></dl>
</li>
</ul>
<a name="getRichStringCellValue()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getRichStringCellValue</h4>
<pre>public&nbsp;<a href="../../../../../org/apache/poi/hssf/usermodel/HSSFRichTextString.html" title="class in org.apache.poi.hssf.usermodel">HSSFRichTextString</a>&nbsp;getRichStringCellValue()</pre>
<div class="block">get the value of the cell as a string - for numeric cells we throw an exception.
 For blank cells we return an empty string.
 For formulaCells that are not string Formulas, we throw an exception</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#getRichStringCellValue()">getRichStringCellValue</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html" title="interface in org.apache.poi.ss.usermodel">Cell</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>the value of the cell as a XSSFRichTextString</dd></dl>
</li>
</ul>
<a name="setCellValue(boolean)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setCellValue</h4>
<pre>public&nbsp;void&nbsp;setCellValue(boolean&nbsp;value)</pre>
<div class="block">set a boolean value for the cell</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#setCellValue(boolean)">setCellValue</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html" title="interface in org.apache.poi.ss.usermodel">Cell</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>value</code> - the boolean value to set this cell to.  For formulas we'll set the
        precalculated value, for booleans we'll set its value. For other types we
        will change the cell to a boolean cell and set its value.</dd></dl>
</li>
</ul>
<a name="setCellErrorValue(byte)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setCellErrorValue</h4>
<pre>public&nbsp;void&nbsp;setCellErrorValue(byte&nbsp;errorCode)</pre>
<div class="block">set a error value for the cell</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#setCellErrorValue(byte)">setCellErrorValue</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html" title="interface in org.apache.poi.ss.usermodel">Cell</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>errorCode</code> - the error value to set this cell to.  For formulas we'll set the
        precalculated value , for errors we'll set
        its value. For other types we will change the cell to an error
        cell and set its value.</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/FormulaError.html" title="enum in org.apache.poi.ss.usermodel"><code>FormulaError</code></a></dd></dl>
</li>
</ul>
<a name="getBooleanCellValue()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getBooleanCellValue</h4>
<pre>public&nbsp;boolean&nbsp;getBooleanCellValue()</pre>
<div class="block">get the value of the cell as a boolean.  For strings, numbers, and errors, we throw an exception.
 For blank cells we return a false.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#getBooleanCellValue()">getBooleanCellValue</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html" title="interface in org.apache.poi.ss.usermodel">Cell</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>the value of the cell as a boolean</dd></dl>
</li>
</ul>
<a name="getErrorCellValue()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getErrorCellValue</h4>
<pre>public&nbsp;byte&nbsp;getErrorCellValue()</pre>
<div class="block">get the value of the cell as an error code.  For strings, numbers, and booleans, we throw an exception.
 For blank cells we return a 0.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#getErrorCellValue()">getErrorCellValue</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html" title="interface in org.apache.poi.ss.usermodel">Cell</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>the value of the cell as an error code</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/FormulaError.html" title="enum in org.apache.poi.ss.usermodel"><code>for error codes</code></a></dd></dl>
</li>
</ul>
<a name="setCellStyle(org.apache.poi.ss.usermodel.CellStyle)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setCellStyle</h4>
<pre>public&nbsp;void&nbsp;setCellStyle(<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a>&nbsp;style)</pre>
<div class="block">set the style for the cell.  The style should be an HSSFCellStyle created/retreived from
 the HSSFWorkbook.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#setCellStyle(org.apache.poi.ss.usermodel.CellStyle)">setCellStyle</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html" title="interface in org.apache.poi.ss.usermodel">Cell</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>style</code> - reference contained in the workbook</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html#createCellStyle()"><code>HSSFWorkbook.createCellStyle()</code></a>, 
<a href="../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html#getCellStyleAt(short)"><code>HSSFWorkbook.getCellStyleAt(short)</code></a></dd></dl>
</li>
</ul>
<a name="setCellStyle(org.apache.poi.hssf.usermodel.HSSFCellStyle)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setCellStyle</h4>
<pre>public&nbsp;void&nbsp;setCellStyle(<a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html" title="class in org.apache.poi.hssf.usermodel">HSSFCellStyle</a>&nbsp;style)</pre>
</li>
</ul>
<a name="getCellStyle()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getCellStyle</h4>
<pre>public&nbsp;<a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html" title="class in org.apache.poi.hssf.usermodel">HSSFCellStyle</a>&nbsp;getCellStyle()</pre>
<div class="block">get the style for the cell.  This is a reference to a cell style contained in the workbook
 object.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#getCellStyle()">getCellStyle</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html" title="interface in org.apache.poi.ss.usermodel">Cell</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>the cell's style. Always not-null. Default cell style has zero index and can be obtained as
 <code>workbook.getCellStyleAt(0)</code></dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html#getCellStyleAt(short)"><code>HSSFWorkbook.getCellStyleAt(short)</code></a></dd></dl>
</li>
</ul>
<a name="getCellValueRecord()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getCellValueRecord</h4>
<pre>protected&nbsp;<a href="../../../../../org/apache/poi/hssf/record/CellValueRecordInterface.html" title="interface in org.apache.poi.hssf.record">CellValueRecordInterface</a>&nbsp;getCellValueRecord()</pre>
<div class="block">Should only be used by HSSFSheet and friends.  Returns the low level CellValueRecordInterface record</div>
<dl><dt><span class="strong">Returns:</span></dt><dd>CellValueRecordInterface representing the cell via the low level api.</dd></dl>
</li>
</ul>
<a name="setAsActiveCell()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setAsActiveCell</h4>
<pre>public&nbsp;void&nbsp;setAsActiveCell()</pre>
<div class="block">Sets this cell as the active cell for the worksheet</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#setAsActiveCell()">setAsActiveCell</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html" title="interface in org.apache.poi.ss.usermodel">Cell</a></code></dd>
</dl>
</li>
</ul>
<a name="toString()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>toString</h4>
<pre>public&nbsp;java.lang.String&nbsp;toString()</pre>
<div class="block">Returns a string representation of the cell

 This method returns a simple representation,
 anthing more complex should be in user code, with
 knowledge of the semantics of the sheet being processed.

 Formula cells return the formula string,
 rather than the formula result.
 Dates are displayed in dd-MMM-yyyy format
 Errors are displayed as #ERR&lt;errIdx&gt;</div>
<dl>
<dt><strong>Overrides:</strong></dt>
<dd><code>toString</code>&nbsp;in class&nbsp;<code>java.lang.Object</code></dd>
</dl>
</li>
</ul>
<a name="setCellComment(org.apache.poi.ss.usermodel.Comment)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setCellComment</h4>
<pre>public&nbsp;void&nbsp;setCellComment(<a href="../../../../../org/apache/poi/ss/usermodel/Comment.html" title="interface in org.apache.poi.ss.usermodel">Comment</a>&nbsp;comment)</pre>
<div class="block">Assign a comment to this cell. If the supplied
  comment is null, the comment for this cell
  will be removed.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#setCellComment(org.apache.poi.ss.usermodel.Comment)">setCellComment</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html" title="interface in org.apache.poi.ss.usermodel">Cell</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>comment</code> - comment associated with this cell</dd></dl>
</li>
</ul>
<a name="getCellComment()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getCellComment</h4>
<pre>public&nbsp;<a href="../../../../../org/apache/poi/hssf/usermodel/HSSFComment.html" title="class in org.apache.poi.hssf.usermodel">HSSFComment</a>&nbsp;getCellComment()</pre>
<div class="block">Returns comment associated with this cell</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#getCellComment()">getCellComment</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html" title="interface in org.apache.poi.ss.usermodel">Cell</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>comment associated with this cell</dd></dl>
</li>
</ul>
<a name="removeCellComment()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>removeCellComment</h4>
<pre>public&nbsp;void&nbsp;removeCellComment()</pre>
<div class="block">Removes the comment for this cell, if
  there is one.
 WARNING - some versions of excel will loose
  all comments after performing this action!</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#removeCellComment()">removeCellComment</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html" title="interface in org.apache.poi.ss.usermodel">Cell</a></code></dd>
</dl>
</li>
</ul>
<a name="getHyperlink()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getHyperlink</h4>
<pre>public&nbsp;<a href="../../../../../org/apache/poi/hssf/usermodel/HSSFHyperlink.html" title="class in org.apache.poi.hssf.usermodel">HSSFHyperlink</a>&nbsp;getHyperlink()</pre>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#getHyperlink()">getHyperlink</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html" title="interface in org.apache.poi.ss.usermodel">Cell</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>hyperlink associated with this cell or <code>null</code> if not found</dd></dl>
</li>
</ul>
<a name="setHyperlink(org.apache.poi.ss.usermodel.Hyperlink)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setHyperlink</h4>
<pre>public&nbsp;void&nbsp;setHyperlink(<a href="../../../../../org/apache/poi/ss/usermodel/Hyperlink.html" title="interface in org.apache.poi.ss.usermodel">Hyperlink</a>&nbsp;hyperlink)</pre>
<div class="block">Assign a hyperlink to this cell. If the supplied hyperlink is null, the
 hyperlink for this cell will be removed.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#setHyperlink(org.apache.poi.ss.usermodel.Hyperlink)">setHyperlink</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html" title="interface in org.apache.poi.ss.usermodel">Cell</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>hyperlink</code> - hyperlink associated with this cell</dd></dl>
</li>
</ul>
<a name="removeHyperlink()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>removeHyperlink</h4>
<pre>public&nbsp;void&nbsp;removeHyperlink()</pre>
<div class="block">Removes the hyperlink for this cell, if there is one.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#removeHyperlink()">removeHyperlink</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html" title="interface in org.apache.poi.ss.usermodel">Cell</a></code></dd>
</dl>
</li>
</ul>
<a name="getCachedFormulaResultType()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getCachedFormulaResultType</h4>
<pre>public&nbsp;int&nbsp;getCachedFormulaResultType()</pre>
<div class="block">Only valid for formula cells</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#getCachedFormulaResultType()">getCachedFormulaResultType</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html" title="interface in org.apache.poi.ss.usermodel">Cell</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>one of (<a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#CELL_TYPE_NUMERIC"><code>Cell.CELL_TYPE_NUMERIC</code></a>, <a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#CELL_TYPE_STRING"><code>Cell.CELL_TYPE_STRING</code></a>,
     <a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#CELL_TYPE_BOOLEAN"><code>Cell.CELL_TYPE_BOOLEAN</code></a>, <a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#CELL_TYPE_ERROR"><code>Cell.CELL_TYPE_ERROR</code></a>) depending
 on the cached value of the formula</dd></dl>
</li>
</ul>
<a name="getArrayFormulaRange()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getArrayFormulaRange</h4>
<pre>public&nbsp;<a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>&nbsp;getArrayFormulaRange()</pre>
<div class="block"><strong>Description copied from interface:&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#getArrayFormulaRange()">Cell</a></code></strong></div>
<div class="block">Only valid for array formula cells</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#getArrayFormulaRange()">getArrayFormulaRange</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html" title="interface in org.apache.poi.ss.usermodel">Cell</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>range of the array formula group that the cell belongs to.</dd></dl>
</li>
</ul>
<a name="isPartOfArrayFormulaGroup()">
<!--   -->
</a>
<ul class="blockListLast">
<li class="blockList">
<h4>isPartOfArrayFormulaGroup</h4>
<pre>public&nbsp;boolean&nbsp;isPartOfArrayFormulaGroup()</pre>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html#isPartOfArrayFormulaGroup()">isPartOfArrayFormulaGroup</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Cell.html" title="interface in org.apache.poi.ss.usermodel">Cell</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd><code>true</code> if this cell is part of group of cells having a common array formula.</dd></dl>
</li>
</ul>
</li>
</ul>
</li>
</ul>
</div>
</div>
<!-- ========= END OF CLASS DATA ========= -->
<!-- ======= START OF BOTTOM NAVBAR ====== -->
<div class="bottomNav"><a name="navbar_bottom">
<!--   -->
</a><a href="#skip-navbar_bottom" title="Skip navigation links"></a><a name="navbar_bottom_firstrow">
<!--   -->
</a>
<ul class="navList" title="Navigation">
<li><a href="../../../../../overview-summary.html">Overview</a></li>
<li><a href="package-summary.html">Package</a></li>
<li class="navBarCell1Rev">Class</li>
<li><a href="class-use/HSSFCell.html">Use</a></li>
<li><a href="package-tree.html">Tree</a></li>
<li><a href="../../../../../deprecated-list.html">Deprecated</a></li>
<li><a href="../../../../../index-all.html">Index</a></li>
<li><a href="../../../../../help-doc.html">Help</a></li>
</ul>
</div>
<div class="subNav">
<ul class="navList">
<li><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFBorderFormatting.html" title="class in org.apache.poi.hssf.usermodel"><span class="strong">PREV CLASS</span></a></li>
<li><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html" title="class in org.apache.poi.hssf.usermodel"><span class="strong">NEXT CLASS</span></a></li>
</ul>
<ul class="navList">
<li><a href="../../../../../index.html?org/apache/poi/hssf/usermodel/HSSFCell.html" target="_top">FRAMES</a></li>
<li><a href="HSSFCell.html" target="_top">NO FRAMES</a></li>
</ul>
<ul class="navList" id="allclasses_navbar_bottom">
<li><a href="../../../../../allclasses-noframe.html">All Classes</a></li>
</ul>
<div>
<script type="text/javascript"><!--
  allClassesLink = document.getElementById("allclasses_navbar_bottom");
  if(window==top) {
    allClassesLink.style.display = "block";
  }
  else {
    allClassesLink.style.display = "none";
  }
  //-->
</script>
</div>
<div>
<ul class="subNavList">
<li>SUMMARY:&nbsp;</li>
<li>NESTED&nbsp;|&nbsp;</li>
<li><a href="#field_summary">FIELD</a>&nbsp;|&nbsp;</li>
<li><a href="#constructor_summary">CONSTR</a>&nbsp;|&nbsp;</li>
<li><a href="#method_summary">METHOD</a></li>
</ul>
<ul class="subNavList">
<li>DETAIL:&nbsp;</li>
<li><a href="#field_detail">FIELD</a>&nbsp;|&nbsp;</li>
<li><a href="#constructor_detail">CONSTR</a>&nbsp;|&nbsp;</li>
<li><a href="#method_detail">METHOD</a></li>
</ul>
</div>
<a name="skip-navbar_bottom">
<!--   -->
</a></div>
<!-- ======== END OF BOTTOM NAVBAR ======= -->
<p class="legalCopy"><small>
                <i>Copyright 2014 The Apache Software Foundation or
        its licensors, as applicable.</i>
            </small></p>
</body>
</html>
